Три правила структурирования данных в Excel из книги Data Modeling with Microsoft Excel:1. В каждом столбце одно поле (например

Магия Excel

Три правила структурирования данных в Excel из книги Data Modeling with Microsoft Excel:

1. В каждом столбце одно поле (например, имя, возраст, оклад или отдел)
2. Каждая строка – одна запись, одна операция — один элемент, в общем.
3. В каждой ячейки одно значение. Если там текст, то не должно быть чисел или других данных. Если вы вводите адрес, города и индексы должны быть в разных столбцах. Тогда вы сможете фильтровать и анализировать данные отдельно по городам и индексам.

Короче говоря, вместо одной ячейки "Оплачено 19.08.2025 218572 руб." должно быть 2 (дата оплаты и сумма) или даже 4 (статус, дата, сумма, валюта). Но точно не все в одной 😊

www.tg-me.com/ms/Магия Excel/com.lemur_excel/612

13.9K viewsMay 12 at 10:45

tg-me.com/lemur_excel/612

Create: 2025-05-12
Last Update: 2025-06-01 09:17:56

BY Магия Excel

Share with your friend now:
tg-me.com/lemur_excel/612

Магия Excel Telegram | DID YOU KNOW?

How to Buy Bitcoin?

Most people buy Bitcoin via exchanges, such as Coinbase. Exchanges allow you to buy, sell and hold cryptocurrency, and setting up an account is similar to opening a brokerage account—you’ll need to verify your identity and provide some kind of funding source, such as a bank account or debit card. Major exchanges include Coinbase, Kraken, and Gemini. You can also buy Bitcoin at a broker like Robinhood. Regardless of where you buy your Bitcoin, you’ll need a digital wallet in which to store it. This might be what’s called a hot wallet or a cold wallet. A hot wallet (also called an online wallet) is stored by an exchange or a provider in the cloud. Providers of online wallets include Exodus, Electrum and Mycelium. A cold wallet (or mobile wallet) is an offline device used to store Bitcoin and is not connected to the Internet. Some mobile wallet options include Trezor and Ledger.

However, analysts are positive on the stock now. “We have seen a huge downside movement in the stock due to the central electricity regulatory commission’s (CERC) order that seems to be negative from 2014-15 onwards but we cannot take a linear negative view on the stock and further downside movement on the stock is unlikely. Currently stock is underpriced. Investors can bet on it for a longer horizon," said Vivek Gupta, director research at CapitalVia Global Research.